const sequelize = require("../db");
const DataTypes = require("sequelize");

const Teacher = sequelize.define("teachers", {
  tNum: {
    type: DataTypes.STRING,
    comment: "教号"
  },
  password: {
    type: DataTypes.STRING,
    comment: "密码"
  },
  grade: {
    type: DataTypes.STRING,
    comment: "年级"
  },
  name: {
    type: DataTypes.STRING,
    comment: "姓名"
  },
  sex: {
    type: DataTypes.STRING,
    comment: "性别"
  },
  position: {
    type: DataTypes.STRING,
    comment: "职位"
  },
  identity: {
    type: DataTypes.STRING,
    comment: "政治面貌"
  },
  subject: {
    type: DataTypes.STRING,
    comment: "学科"
  },
  nation: {
    type: DataTypes.STRING,
    comment: "民族"
  },
  birthdate: {
    type: DataTypes.STRING,
    comment: "出生日期"
  },
  census: {
    type: DataTypes.STRING,
    comment: "户籍"
  },
  phone: {
    type: DataTypes.STRING,
    comment: "手机"
  },
  address: {
    type: DataTypes.STRING,
    comment: "地址"
  }
});

module.exports = Teacher;
